SQL Formatter & Beautifier
Validate SQL
Format SQL
SQL Editor
Clear
Load Sample
SELECT customers.customer_id, customers.first_name, customers.last_name, orders.order_date, products.product_name, order_items.quantity, (order_items.quantity * products.price) as total_amount FROM customers INNER JOIN orders ON customers.customer_id = orders.customer_id INNER JOIN order_items ON orders.order_id = order_items.order_id INNER JOIN products ON order_items.product_id = products.product_id WHERE orders.order_date >= '2023-01-01' AND customers.country = 'USA' ORDER BY customers.last_name, customers.first_name, orders.order_date DESC;
Formatted SQL
Copy SQL
Indentation:
2 Spaces
4 Spaces
8 Spaces
Tabs
Keyword Case:
UPPERCASE
lowercase
Capitalize
Options:
Align columns
Newline before clauses
Strip comments
SQL Dialect:
Standard SQL
MySQL
PostgreSQL
SQL Server
Oracle
SQLite
Characters: 0
Lines: 0
Last update: Just now
Query type: Unknown
SQL Validation
×